sql 查询当月及全年每个用户累计销售量答:id=A.idGROUP BY B.id, NAME, left(date,4)UNION ALLSELECT B.id, name, left(date,6) dt, sum(money) as 当月FROM B LEFT JOIN A ON B.id=A.idWHERE date BETEEN '204-1-1' AND '2014-1-31'GROUP BY B.id, NAME, left(date,4) ORDER BY B.id, NAME, left(date,4)...